{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["June 14 Calculator"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"June 14 Calculator","index":0,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,33,7,33],[6,34,7,34],[0,0,0,27]]}
["June 14 Calculator"]
[null,"q1","q2","q3","q4","q5","q6","q7","q8a","q8b","q8c","q9","q10","q11","q12a","q12b","q13","q14","q15","q16","q17","q18a","q18b","q19","q20","q21a","q21b","q22","q23","q24","q25","q26","q27"]
[null,"Midpoint"," Scattergraphs"," Substitution"," Area and Circumference of Circles","Translations "," Compound Measures"," Angles in Parallel Lines","Probability ","Probability and Relative Frequency","Sampling"," Forming and Solving Equations","Index Notation","Functional Maths Questions "," Sequences","Quadratic Sequence Reasoning","Inequalities ","Worded LCM Questions"," Trigonometry"," Standard Form"," Similar Shapes"," Compound Interest & Depreciation","Reverse %","3D Co-ordinates","Missing Mean Questions"," Expand & Factorise Quadratics","Proof","And Or Probability"," Stratified Sampling"," Direct & Inverse Proportion"," Spheres and Cones"," Simultaneous Equations with a Quadratic"," Sine, Cosine Rules & Area of Triangles"]
["Max Mark",2,4,2,2,2,3,3,2,2,2,4,4,5,2,1,4,5,7,2,4,3,3,2,3,2,3,3,3,3,3,5,5]
["Class Average (%)",{"$f":"AVERAGE(B9:B40)/B4","v":0.42857142857142855},0.26785714285714285,0.5357142857142857,0.5535714285714286,0.5,0.26190476190476192,0.25,0.39285714285714285,0.5,0.44642857142857145,0.2767857142857143,0.22321428571428573,0.24285714285714283,0.5357142857142857,0.8928571428571429,0.26785714285714285,0.21428571428571427,0.10204081632653061,0.44642857142857145,0.22321428571428573,0.32142857142857145,0.32142857142857145,0.5357142857142857,0.33333333333333331,0.5535714285714286,0.27380952380952378,{"$f":"AVERAGE(AB9:AB40)/AB4","v":0.32142857142857145},0.34523809523809529,0.34523809523809529,0.33333333333333331,0.22857142857142856,0.22142857142857145]
["Standard Deviation",{"$f":"IF(COUNT(B9:B36)<2,\"\",STDEV(B9:B40)/B4)","v":0.35261682367496922},0.19158901118370333,0.38317802236740667,0.31444500532789738,0.40824829046386302,0.20998026278290402,0.19510469912690256,0.36911161759471384,0.38490017945975052,0.3426283407632531,0.18433169722859552,0.17131417038162655,0.12598815766974242,0.3313432657960016,0.78595474915854269,0.17909974756185329,0.13253730631840063,9.4097478100890836E-2,0.39297737457927134,0.15722250266394866,0.23097828906119441,0.2793605699491753,0.35819949512370658,0.28688765527462345,0.31444500532789738,0.25745783830903407,{"$f":"IF(COUNT(AB9:AB36)<2,\"\",STDEV(AB9:AB40)/AB4)","v":0.2642193697809283},0.24815604504531782,0.24815604504531782,0.18144368465060579,0.1410467294699877,0.16634890342878031]
[null,"q1","q2","q3","q4","q5","q6","q7","q8a","q8b","q8c","q9","q10","q11","q12a","q12b","q13","q14","q15","q16","q17","q18a","q18b","q19","q20","q21a","q21b","q22","q23","q24","q25","q26","q27","Total Marks","Grade"]
["Name"]
["Sample student 1",{"$f":"ROUND(RAND()*$B$4,0)","v":2},2,1,0,2,1,1,0,2,1,1,0,2,1,2,2,{"$f":"ROUND(RAND()*$B$4,0)","v":1},0,2,1,1,1,2,2,2,0,2,0,2,1,2,1,{"$f":"IF(AG9=\"\",\"\",SUM(B9:AG9))","v":40},{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,$AK$13:$AL$34,2))","v":"C2"}]
["Sample student 2",1,0,0,1,0,0,1,1,2,1,1,2,2,0,1,1,1,1,1,1,1,1,0,2,1,2,1,1,1,1,2,1,{"$f":"IF(AG10=\"\",\"\",SUM(B10:AG10))","v":32},{"$f":"IF(AH10=\"\",\"\",VLOOKUP(AH10,$AK$13:$AL$34,2))","v":"C3"},null,"Grade Boundaries"]
["Sample student 3",1,0,1,2,0,1,1,0,0,0,2,1,0,1,1,1,0,0,0,0,2,0,1,1,1,2,2,1,1,1,1,0,25,"D1"]
["Sample student 4",1,0,1,0,0,1,1,0,1,1,0,0,1,1,2,1,0,0,0,1,0,0,0,2,2,0,0,2,2,0,1,0,21,"D2",null,"Non- Calc"]
["Sample student 5",2,2,0,2,1,1,1,0,0,0,2,1,0,0,0,2,2,1,2,2,2,2,0,2,1,1,1,0,0,1,0,0,31,"C3",null,0,"F3"]
["Sample student 6",0,1,2,0,0,2,0,0,1,1,1,2,1,2,2,1,1,1,2,1,0,2,2,2,1,1,0,1,0,1,0,0,31,"C3",null,2.3333333333333335,"F2"]
["Sample student 7",2,1,1,1,2,0,2,0,0,0,1,0,1,1,1,2,2,0,1,1,1,0,1,0,1,1,1,1,1,2,1,2,31,"C3",null,4.666666666666667,"F1"]
["Sample student 8",1,1,2,1,0,1,1,1,0,2,2,0,1,1,1,2,0,0,2,0,0,2,1,2,1,0,0,2,2,0,2,2,33,"C3",null,7,"E3"]
["Sample student 9",0,1,1,1,1,1,1,2,2,0,2,1,2,0,0,1,1,0,1,0,1,0,0,0,1,0,0,1,1,1,1,1,25,"D1",null,9.3333333333333339,"E2"]
["Sample student 10",1,1,2,1,1,0,1,2,1,0,1,2,1,1,1,1,2,1,0,1,1,2,2,1,1,1,1,0,1,1,1,0,33,"C3",null,11.666666666666668,"E1"]
["Sample student 11",1,1,2,1,0,0,1,2,2,1,0,1,2,1,2,0,1,1,2,1,1,1,1,1,2,1,2,0,2,1,2,1,37,"C2",null,14,"D3"]
["Sample student 12",0,2,0,2,1,1,0,1,0,1,0,0,1,1,0,0,1,0,1,2,0,1,1,0,0,0,2,1,2,1,2,2,26,"D1",null,19,"D2"]
["Sample student 13",1,0,1,1,0,0,1,2,1,2,2,0,1,1,1,0,1,1,1,0,0,1,2,1,1,2,0,0,1,1,2,1,29,"C3",null,24,"D1"]
["Sample student 14",0,1,1,1,2,0,0,0,2,1,2,2,1,1,0,1,1,0,1,0,2,1,1,1,1,1,2,2,1,1,0,1,31,"C3",null,29,"C3"]
["Sample student 15",1,0,1,2,1,1,0,1,1,0,1,1,1,1,0,2,2,1,1,1,1,1,1,0,1,0,1,2,1,1,2,0,30,"C3",null,35.333333333333336,"C2"]
["Sample student 16",0,1,1,1,1,1,2,0,1,1,2,1,0,1,2,{"$f":"ROUND(RAND()*$B$4,0)","v":1},0,1,0,1,1,1,2,0,0,2,1,1,0,1,1,2,30,"C3",null,41.666666666666664,"C1"]
["Sample student 17",{"$f":"ROUND(RAND()*$B$4,0)","v":1},1,0,2,1,1,0,1,0,1,1,1,1,1,0,1,2,1,2,1,2,0,1,2,2,1,0,{"$f":"ROUND(RAND()*$B$4,0)","v":1},0,1,1,0,30,"C3",null,48,"B3"]
["Sample student 18",1,1,2,1,1,0,1,2,2,1,0,1,1,2,0,2,0,1,0,2,0,0,1,0,1,1,2,2,1,0,1,1,31,"C3",null,54.333333333333336,"B2"]
["Sample student 19",2,1,0,2,2,1,1,1,1,2,1,1,1,0,2,1,1,1,2,1,0,2,2,2,2,0,1,2,1,1,1,2,40,"C2",null,60.666666666666664,"B1"]
["Sample student 20",1,2,1,1,0,1,0,1,0,2,2,1,1,0,0,0,1,2,0,1,1,0,1,2,1,0,2,0,1,1,1,2,29,"C3",null,67,"A3"]
["Sample student 21",2,2,0,1,1,1,1,1,2,2,1,1,2,2,1,1,1,1,0,2,1,2,0,0,2,0,0,1,0,1,0,2,34,"C3",null,72,"A2"]
["Sample student 22",0,2,2,1,1,2,0,1,2,1,0,1,2,2,2,1,1,0,1,0,2,0,2,2,0,1,1,0,0,1,2,1,34,"C3",null,77,"A1"]
["Sample student 23",0,2,0,1,2,0,0,1,1,1,1,0,1,1,0,2,2,0,0,1,1,0,0,0,1,2,1,1,2,2,1,2,29,"C3",null,82," A*3"]
["Sample student 24",1,0,2,2,2,2,1,1,0,1,1,1,2,2,0,2,1,1,0,0,1,2,1,1,1,1,1,1,1,1,1,2,36,"C2",null,88,"A*2"]
["Sample student 25",0,2,2,1,2,1,0,0,1,1,1,2,1,1,1,0,1,1,1,1,1,1,2,1,0,2,1,2,1,2,1,1,35,"C3",null,94,"A*1"]
["Sample student 26",0,2,2,0,0,1,1,1,1,0,2,0,2,2,1,1,1,0,1,1,2,2,1,0,1,0,2,2,2,1,0,2,34,"C3",null,100,"A*1"]
["Sample student 27",1,1,1,1,2,1,1,0,1,1,0,1,2,2,1,1,1,2,1,1,1,0,1,1,2,1,0,1,2,2,1,0,34,"C3"]
["Sample student 28",{"$f":"ROUND(RAND()*$B$4,0)","v":1},{"$f":"ROUND(RAND()*$B$4,0)","v":0},1,1,2,0,1,0,1,0,1,1,1,1,1,0,2,2,0,1,1,2,1,0,1,0,0,1,0,0,2,2,27,"D1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]